You are here: AgileShapes > SharePoint > CAML Query

CAML Query

This AgileShape can be used to create a SharePoint view based on available fields using a CAML query. You can use the CAML Query Builder AgilePart to create your CAML query, and your view.

 

Design-Time Properties

NOTE: Since this AgileShape is a specialized sub-type of the AgilePart AgileShape, all of the standard properties supported by the AgilePart AgileShape are also supported by this AgileShape. Since they are already documented elsewhere, the standard AgilePart properties are not documented in this section. Refer to the documentation for the AgilePart AgileShape for information about the standard AgilePart properties. Additional design-time properties (other than the standard AgilePart properties) that are specific to this AgileShape are documented below.

 

Configure

This property enables you to configure a CAML query. Click the Ellipses button to open the CAML Query Builder Configuration dialog box (as shown below).

 

 

To configure the CAML query and create your view from available fields:

  1. Enter the site URL in the Site Url textbox and click Connect. The various Lists and Document libraries are loaded in the List Name drop-down.
  2. Select Show hidden fields if you want to use the SharePoint hidden fields in the CAML Query.
  3. Select the List. All the columns in the selected list will be loaded in the Possible View Fields box.
  4. Move the required columns to the Configured View Fields list.
  5. Configure the Where clause by selecting a nest type -- And or Or.
  6. Select the columns required for the condition.
  7. Select the Column to order the data by and the Sort Type.
  8. Click the Query Options tab, and select options such as the maximum number of rows (Row Limit), whether to include mandatory columns, Folder location and Group By Column.
  9. Click the Output Mapping tab, and map the nodes from SharePoint column to the InfoPath schema.

 

If the output type is an InfoPath form, the results from the operations performed by the CAML Query AgilePart are automatically updated in the InfoPath form. The following conditions apply:

• The InfoPath form must have a repeating table which can be mapped to the row node.

• The columns must be mapped to this repeating table.

• The ItemCount node will contain the number of rows returned by the CAML Query. This can also be mapped if required.